exports.path = '/example/createProcedure';
exports.title = '创建存储过程';
exports.pool = 'task';

exports.sqltext = `
CREATE OR REPLACE PROCEDURE get_tab_num_rows (tname IN VARCHAR2, num_rows OUT NUMBER) AS
BEGIN
  SELECT num_rows INTO num_rows FROM user_tables WHERE table_name = upper(tname);
END;
`;

exports.request = {};
